[dbo].[BAEImisNameAddressGetByPurpose]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisNameAddressGetByPurpose

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Id	varchar(10)	10
@addressPurpose	varchar(20)	20

SQL Script

create procedure [dbo].[BAEImisNameAddressGetByPurpose] @Id varchar(10),
     @addressPurpose varchar(20) as
SELECT ADDRESS_NUM
    FROM Name_Address
    WHERE ID = @Id AND PURPOSE = @addressPurpose

GO

Uses

[dbo].[Name_Address]
dbo